<?php 
set_time_limit(0);
include '../c/config.php';
$Data=explode("\n", file_get_contents('./1.txt')) ;

$mysqli = new mysqli($dbhost, $dbuser, $dbpwd, $dbName);
if (!$mysqli->set_charset("utf8")) {printf("Error loading character set utf8: %s\n", $dbhost.$mysqli->error);}


foreach ($Data as $v){
    
    $getU=explode("\t", $v);
    //var_dump($getU);
    $name=addslashes(trim($getU[0]));
    $idc=addslashes(trim($getU[1])); 
    
    
    $queryJ=$mysqli->query("SELECT id from `uinfo_sim` where name='".$name."' and idcard='".$idc."'  limit 0,1 ");
    if($queryJ->num_rows>0){
        $getidD=$queryJ->fetch_assoc();
        echo $name,' : ',$getidD['id'];
    }else{
        echo $name,' .... ','没找到';
    }
    echo "<br />";
}


$mysqli->close();

?>